SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetEmployersName]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	SELECT JOL_Employer_No,JOL_Employer_Name FROM dbo.JOL_Employer ORDER BY JOL_Employer_Name
	RETURN
GO
